SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040524 LIMIT 1 [ RunTime:0.000515s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040524 [ RunTime:0.002486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681555,836180,208968,458408,932464,512027,470568,860594,794095,367354,243842,480388,439441,877917,471745,648258,659725,105875,212252,334844,1036690,1008596,703353,421731,711387,667521,436166,150690,516750,794824,175116,1047768,869516,153829,33786,119612,932144,195083,336947,836018,406696,188318,1029827,83117,344363,114210,679062,996653,332604,881708,558050,196758,890846,665504,265100,186550,548756,439139,880366,642673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]