SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000508 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000508 [ RunTime:0.006367s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020946,385002,226365,91892,801503,331441,944114,701953,963345,865477,902473,190206,1042090,572876,251594,487555,673319,1033130,682833,797648,817321,123126,747231,191978,880916,760134,4192,367901,723825,356053,487742,558699,364740,392312,585006,434563,361698,400849,716807,923089,93724,563559,108840,528228,368551,365839,885997,620288,103769,838814,638694,167128,62547,860679,843878,114015,227902,488467,104655,180374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]