SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102643 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102643 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690523,909838,909628,531282,739435,208809,581345,301507,420214,890508,647217,187939,669672,32332,330377,1031705,739583,271600,224748,205235,26248,974130,146928,695933,492848,759263,570701,1004175,500185,434233,456455,268907,446735,12653,218631,289497,604946,50604,346628,954028,653093,464129,974140,131922,242815,1026330,324142,1003811,334031,318227,609248,1004712,637906,768158,906426,664575,923534,270789,46355,964928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]