SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041282 LIMIT 1 [ RunTime:0.000617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041282 [ RunTime:0.002602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513767,627097,528217,308423,448716,542642,531490,428096,1031943,109630,160811,859180,476531,391616,188402,503385,284015,444773,522287,436418,739025,644801,23368,507204,941519,593769,729057,21561,867488,319068,137793,279312,811072,1020089,884586,783567,1037114,51005,342103,864947,446881,150958,383826,694320,504645,501619,434196,689448,187945,467572,189619,796645,523828,657943,116575,20827,358019,790207,130775,602063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041282 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041282 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]