SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464860 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464860 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792164,916040,848610,924093,644518,22159,863090,307626,485653,565845,552840,579420,475588,444750,21967,773209,2698,603025,23110,752171,299820,1015666,160513,321856,572674,130311,421289,179503,247058,15537,223612,506556,491986,664612,874948,48654,930580,646586,723838,481051,905076,152018,173681,358177,732404,951886,783279,227865,848768,965088,901608,646175,560658,245144,110023,665155,314116,550805,18495,506946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000986s ]