SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810551 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810551 [ RunTime:0.002805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021403,87747,987960,343640,221534,780583,1040394,131866,441092,458605,671398,435481,825894,152990,797646,181535,36471,466394,371555,174683,921482,117421,20114,683141,737166,119918,265433,20311,43154,9380,324817,782920,910810,160134,603887,208722,389836,643520,417746,504490,95587,40271,1022837,51577,1031543,844560,515715,622561,833983,874475,971073,606277,824924,955926,102113,325913,1041214,394389,328054,906709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]