SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54998 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54998 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019472,250125,352544,402823,951965,221212,426624,886477,898236,947092,111932,503422,103848,501915,430555,981730,780116,454781,892646,752210,176489,356776,796508,824522,464532,209646,120831,552488,945952,364318,145901,210217,379919,856592,665278,805346,656338,68688,861140,213493,46949,329995,340869,814185,498683,396377,792868,1004303,788123,200659,419247,935430,569952,423198,377477,411806,802491,273148,332285,980624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]