SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10842 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10842 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377127,918481,202733,417784,1048101,809982,866081,840523,701598,921443,481828,824241,91399,846563,524863,401859,832769,857982,461773,171308,187602,72922,365913,300435,229068,664270,851564,582140,552507,284251,842787,161213,409200,830174,504150,883038,645306,910312,332358,3304,25149,483324,59613,595997,879859,985878,765622,747500,645834,20546,300631,355165,680842,261511,371518,195745,753923,196366,978307,948280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]