SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314083 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314083 [ RunTime:0.001478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51935,265019,686946,745182,439538,174890,563774,560832,436986,924224,563527,745371,672427,92988,348983,713365,999485,678847,741685,905370,221595,272936,127762,990916,795620,148888,1040275,486076,782124,996447,308368,444735,253050,790106,303500,567343,744915,475143,142590,231521,34618,925241,274097,391221,708424,422126,71559,267146,470649,878267,855947,508191,297942,953792,992330,298826,186193,746883,428662,135991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]