SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440097 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440097 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305670,115227,389105,810250,737797,812856,16914,793686,577867,386108,16049,790894,776199,942933,1024291,1038215,469300,78217,785593,253429,270804,550954,43261,886565,143768,923886,947616,40623,939651,447402,159664,436219,472733,319733,3729,812342,981496,116805,73380,261196,744530,434353,401607,145607,912362,284269,719477,904483,643252,207538,989886,873473,433820,990325,324019,821617,641202,98655,599476,918364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]