SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004014s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401529 LIMIT 1 [ RunTime:0.000962s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401529 [ RunTime:0.003531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258650,1005913,857976,272840,1026440,178684,136834,1019797,345263,787540,478338,306252,762600,823875,836994,518043,533116,522713,558143,635460,201845,86801,823514,300971,194981,524696,217357,135599,223406,963438,215116,274503,149382,303366,663488,93174,754775,682958,153690,449332,583052,359847,642301,297022,7087,1045029,594435,676486,792724,864096,426179,102004,622498,761222,44413,202880,637520,259210,807959,781912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]