SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419374 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419374 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347892,895914,280892,399142,1007379,237886,567873,833405,680715,60010,611776,539979,929733,709738,335630,708795,864338,466419,829182,295800,924470,776896,286414,178923,838467,129201,535856,28302,672555,902581,1043129,235485,490749,863676,225824,775217,961499,648480,201213,564969,579182,929657,616518,732000,774444,957585,705200,359985,763843,735332,84385,468546,943198,183466,225750,857768,829041,531147,704326,710993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419374 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419374 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]