SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 642163 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 642163 [ RunTime:0.002181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463050,681067,129977,718695,745719,413948,642801,383321,351411,247109,1035409,506957,847101,869241,297409,1012187,861085,509149,644174,1032487,961254,12034,555295,202881,313836,301282,957577,178718,684603,1020938,845487,612216,694504,168066,336439,627143,686913,935362,287573,99087,231222,1009854,302663,289212,166308,938143,97939,763294,797414,373567,270058,153660,700128,882933,201683,560718,86039,859003,685246,798580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 642163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 642163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]