SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343870 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343870 [ RunTime:0.003701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108065,750945,332613,890139,335728,636228,899685,835264,241592,815105,62353,354300,805301,270675,507584,519368,81041,1007645,213310,1011455,100188,1008524,607191,44907,692761,790042,558098,128540,14236,36476,229051,128391,1030108,476061,286175,517820,1007808,681852,259520,909651,471400,943147,562108,408400,753603,316008,491850,469328,164302,475260,298990,335692,50437,493750,1025804,133745,178337,987159,219526,344281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004075s ]