SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001828s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567535 LIMIT 1 [ RunTime:0.000722s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567535 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943587,12471,458326,126390,844002,205192,660752,14255,753004,197661,470151,565757,948434,61433,833231,29451,388473,589417,502349,789562,301978,225322,353893,160509,560360,603523,33765,55914,473112,406928,597422,114237,739438,539695,250798,479251,160538,939216,639618,340184,910878,142923,149141,759890,491068,727483,826199,265902,96600,1021567,990833,7541,203052,452428,257443,831403,380916,945563,735687,473205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]