SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149092 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149092 [ RunTime:0.002411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523781,378420,388642,716883,821496,213291,895083,498332,1021787,1007182,693086,576399,396903,975306,97315,250605,529373,391231,753413,375773,1039001,689768,992828,1043724,127561,463138,133488,673856,930902,861306,398887,488463,803857,702042,916618,266130,302180,873586,175812,171186,429524,286862,602136,93843,659915,514362,461419,91417,978069,34486,110033,1007627,640518,132402,246201,162783,301997,929582,990830,592797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]