SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 680076 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 680076 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222538,605100,104050,305530,497287,771775,840970,47301,650160,118692,1047489,803075,129426,62097,585868,891768,651748,96217,247572,713208,280950,322015,93303,568605,382812,830622,474556,704526,816234,198500,802245,171423,249760,696003,289222,625451,535275,195033,279526,11260,930796,538237,129561,345744,865628,51347,399640,1003784,28842,687334,621000,136348,857106,324073,476045,854692,331072,455997,579026,823598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 680076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 680076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]