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` = 1045203 LIMIT 1 [ RunTime:0.007000s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045203 [ RunTime:0.002125s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507654,852725,894121,825026,849171,981437,885570,372018,695824,321332,233371,574223,293839,56168,273926,20985,608487,426700,463280,11121,588618,853735,677395,998213,414432,384829,881369,359147,1000804,914553,465827,175462,48281,253161,315384,135193,902505,1047108,624133,971237,153153,891511,67995,674820,656675,655420,1040111,285526,751267,503461,975440,951173,466585,755214,24461,546174,781246,372980,614548,937846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]