SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543830 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543830 [ RunTime:0.004709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801723,337865,592471,863774,242156,996747,111464,448896,147725,628871,663759,572544,898510,649254,159204,35201,532550,540103,401932,1024915,710751,879263,274838,1010072,718833,257078,410601,725370,415890,455965,871675,1042164,381321,569176,544495,752059,123531,103677,102562,231250,231602,941530,34820,674241,34378,48379,754586,169846,484432,73088,373600,243922,727210,180983,40460,575432,577014,770954,927662,546642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]