SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002761s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515006 LIMIT 1 [ RunTime:0.002428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515006 [ RunTime:0.004709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819151,311945,363120,565194,975556,619569,763291,312842,782954,543530,749288,944121,647248,734803,925353,689923,673156,203385,26387,514510,1040412,268166,522310,562826,175989,252698,611440,785245,827503,348665,183328,765567,644946,11938,262680,279326,237478,243715,993843,916141,899810,964945,747618,163006,698274,201601,475253,91666,865867,1045859,953169,452285,635595,108813,570123,253047,730325,1027341,876732,134100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]