SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51016 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51016 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457305,119299,350955,564882,999643,924456,1006585,847199,487806,314377,922381,833500,831588,304919,783482,373973,367271,262096,346032,393398,359118,1022965,153694,4905,519336,421984,272008,498451,209962,998393,436284,724068,1047775,115328,81381,601887,136964,327931,698831,1000160,541606,123657,51343,59231,81543,383817,415764,358392,786657,422045,828284,843877,107900,777826,93926,702268,300023,663990,880984,201687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]