SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685271 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685271 [ RunTime:0.005111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801023,231116,516593,488822,19682,454523,224252,1044458,560054,39166,618648,607055,537515,426971,1001847,327940,961867,971152,895379,805870,589853,117872,371010,114740,393035,737284,843820,848687,786003,55460,87839,623407,341655,826084,132936,741327,974275,564230,143610,847038,146996,197337,36542,176278,896810,252931,462573,635916,67400,112638,575361,490068,268218,18538,823517,206643,660334,259010,427358,518330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]