SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982811 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982811 [ RunTime:0.003328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197390,1046190,449280,803731,432382,919050,774705,1006401,10427,264818,792236,1004569,687862,437350,365388,524874,401242,473017,450722,867051,357537,635570,121841,356095,342645,981602,681262,611680,493805,219908,843133,288082,201387,844771,852753,145948,150683,208497,889635,962496,419613,31342,634900,414543,294960,311579,600711,678371,518659,586495,431447,539610,443524,101394,379045,437885,688217,461752,865829,307581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]