SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414016 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414016 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617621,623812,243654,44681,289149,283537,1021785,999609,945844,512624,490906,274451,743773,467345,224017,249290,593645,768357,753048,871356,708936,680019,927196,644379,645684,355194,384841,261398,27646,499503,227691,47808,618346,239410,794832,474111,118079,365677,569618,664413,755554,124952,662632,295601,991718,217690,41222,1000498,388977,403973,165035,362893,173486,68292,479811,261347,161712,349975,431847,424015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]