SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106508 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106508 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919266,895853,522871,53730,496350,460257,459189,288540,50743,966190,240364,675857,214503,535368,86157,256697,174808,926755,44511,47813,971785,123705,556447,449853,931530,619583,805736,233857,817758,846851,426448,679365,144477,333416,582192,171407,796080,958446,31085,174742,121287,163568,330890,198555,236134,430612,2047,238976,68108,400400,603765,429147,361426,594071,567884,621483,443521,659430,555660,680551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000848s ]