SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002955s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427433 LIMIT 1 [ RunTime:0.001289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427433 [ RunTime:0.002329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029842,821905,351898,643121,767741,437513,416,825354,869427,1001103,1009333,919140,141002,684488,657713,228740,1016506,976518,416840,187015,333682,40800,826858,11863,87922,737191,358058,1006871,296054,825603,803486,771470,838604,565904,187451,291079,595279,440769,603976,356726,1048123,214100,145817,435826,230377,435801,299467,116039,973743,502107,307786,69979,871377,310248,616437,374238,445642,924154,507389,531004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002067s ]