SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501679 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501679 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167954,28584,582629,190743,404895,422872,697551,56231,525903,299917,604415,112351,379471,59677,630795,148285,1016524,48977,558312,607184,1005789,84313,956893,841285,722772,621570,142290,588262,888084,795760,604808,678461,200850,426869,359110,291311,506586,791769,637954,224748,604850,13627,132448,778960,754829,958982,401022,625957,476870,908138,842652,153216,10546,725570,373197,757871,33878,28050,436137,331313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000928s ]