SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805080 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805080 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937916,78844,58761,927064,293581,547540,586442,309826,752126,981097,977995,654262,653333,276804,59816,448025,36965,450794,856672,896473,258913,514429,519826,423160,125104,1038012,162539,539184,622204,132058,579379,575436,173546,1018650,368694,661396,725469,743886,588000,2540,744843,617455,328719,74939,353828,338194,726672,479093,1028710,773542,126537,111460,955983,20811,966805,77183,479061,643347,437654,417582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]