SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10713 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10713 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43010,295340,600406,273930,413429,668183,724033,647729,670580,28576,280755,826817,630256,452453,4121,162013,271434,481289,160297,820846,576395,977796,630117,406639,716895,203653,283022,59251,1021101,325880,945545,893918,85180,445835,53818,297288,793472,866861,202713,266583,921058,554922,394092,95744,184445,401179,687642,279978,611774,336609,841235,831293,558526,515137,496296,109955,628359,1047495,369469,349783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001052s ]