SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492072 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492072 [ RunTime:0.001875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496833,795015,639742,659700,585393,47818,315369,138597,1012467,209874,492333,8883,288929,642442,1008798,106497,292506,813000,137395,994058,346848,329650,1013865,68270,1001346,104183,670648,628457,686012,945487,1002651,635783,843225,822983,358476,805411,262970,156386,66782,220046,161558,436209,719545,49986,105220,909146,169475,645093,970766,907492,974358,52258,236678,144720,130678,269925,34540,524208,873335,233208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]