SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035818 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035818 [ RunTime:0.005551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6907,127331,320360,167496,447604,893507,291697,1001744,636685,840766,75541,581539,56113,388538,452415,393700,1015795,879250,93328,1013203,631219,284146,429784,412029,862170,993805,367849,348568,795652,410396,60891,128411,920529,687871,105375,126201,759060,768773,237275,847258,715486,135982,919648,276457,752423,46274,547698,171528,514997,332767,364579,676937,785523,1025630,214444,806428,434475,409027,538571,242395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]