SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505911 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505911 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018671,515311,240155,547180,501950,374110,1030939,337781,344156,355395,636272,1033901,707451,383347,89654,383437,991955,750161,678775,393218,687624,582460,525309,434283,246140,1019321,113029,1000722,89742,831291,89788,317825,21287,1007854,581963,693268,974404,742489,525703,519069,944528,457071,53937,51221,450036,428448,154822,333735,175860,193016,865773,504935,135476,336470,129577,531281,771980,243752,290860,396562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]