SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034252 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034252 [ RunTime:0.002228s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791905,613550,487438,313641,562835,1035454,39578,227541,204591,239510,3981,36966,928388,441855,191674,840375,646242,260013,271543,728588,640447,33997,604866,259429,750854,375526,489114,194253,405444,714907,434071,537329,44818,105556,974960,344598,569673,244032,795104,999663,231370,279939,750815,299833,51792,311578,71798,805752,250836,379278,1029226,1011001,618022,529189,1024144,622200,848218,972236,707300,129005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002143s ]