SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469943 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469943 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309188,533630,544675,69764,432733,261355,320333,431390,11939,903041,468847,922910,303120,188028,760624,666986,713932,309196,333912,901894,62549,753074,578299,576377,138956,424537,883848,205691,507625,1034389,860000,727179,601747,372328,418265,432047,857132,1030076,497124,483864,24906,998527,229776,827718,96505,443047,950768,167030,171200,356691,949049,681538,18660,949470,435353,501551,901928,564686,680145,619263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]