SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534907 LIMIT 1 [ RunTime:0.000689s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534907 [ RunTime:0.002524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199703,1038319,179547,459859,248487,322651,1012538,160037,879365,971014,5233,563782,51016,270218,421754,203902,528590,676784,1004392,281400,484210,950036,754086,793861,491823,966283,56765,994090,853215,1045810,3512,167741,190216,33309,853297,835624,743614,89900,158460,1024036,228594,132149,834848,1027441,283926,959202,411460,979594,979843,180378,403464,99469,146928,988562,604510,661039,841408,877221,159980,660248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]