SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001729s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804916 LIMIT 1 [ RunTime:0.000520s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804916 [ RunTime:0.004390s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258432,958953,716114,914331,875757,6513,153925,708586,741248,480728,762150,675206,897160,979187,797635,59608,662120,24629,905440,230475,965802,334688,983430,664951,84275,375858,468499,994257,805595,1028885,538964,328696,363418,680705,607733,707104,413192,259221,578342,1027754,364356,504381,925937,175123,577669,763708,987678,271950,782149,979632,576741,694796,509889,256631,99357,672244,862039,907601,85245,744907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003394s ]