SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002020s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020302 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020302 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398994,642405,37879,232744,278542,143202,93148,993212,389253,25800,929104,501351,134089,95198,183290,388349,727468,650874,937295,639101,404020,281985,172927,305335,733440,581638,682115,416630,648016,411421,861650,239716,48858,526492,200065,269267,974477,761525,957133,719622,640066,741178,499120,76096,731179,778465,717733,498721,979721,591671,346900,321024,83570,747198,964473,31949,895139,880659,117921,161721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]