SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267502 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267502 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410400,708482,901568,360197,740439,1045079,126866,191087,467774,770330,556819,409322,426410,267608,847343,819516,363343,250909,296388,959353,638734,914035,370497,41830,581692,825775,144073,207054,1003312,740870,566753,531864,796918,808034,693673,142722,110298,49051,371421,324121,122171,878576,155701,139427,603348,865925,591501,60835,417318,483917,732826,692806,154398,940350,170788,99988,802060,542654,234822,315106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]