SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419681 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419681 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450258,90964,453536,434449,483152,513340,27881,249838,587172,1038008,592501,823874,632634,296145,991013,129826,88883,514902,718607,917855,816740,669262,168990,204009,689063,768183,780367,678531,18552,236306,675491,1000856,772028,578936,423192,316166,645182,261438,852431,65742,119107,122412,512872,645321,974636,118260,131893,630959,963081,700341,939068,366712,1009204,709021,442553,778660,700313,512047,415328,1040695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000770s ]