SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599871 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599871 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991691,943969,505798,73731,588826,345229,792045,266472,1033553,299514,842860,721139,547683,283718,879512,895405,556507,166115,75060,938491,840882,946464,1035336,427340,317345,984371,564680,458904,671348,765343,731494,498099,338608,618394,894108,450285,330759,454220,308688,645955,270735,358738,1015226,683871,262849,811405,477077,255518,671290,572933,191747,513997,42880,504199,866921,42310,76071,408955,1000005,175717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]