SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416270 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416270 [ RunTime:0.002347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516104,183317,188261,862844,962421,1031790,393419,903824,611767,329611,991608,194119,373249,981625,531573,632056,18229,967331,175591,180579,105136,230761,657840,879541,383285,343994,201474,877136,497566,938139,522440,934573,113146,282499,1017744,848949,762042,128139,857553,374196,271645,526673,73293,924254,156809,889853,953831,666783,796347,365409,490411,983629,640843,123583,315696,1016345,267077,381909,349768,543833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000949s ]