SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505595 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505595 [ RunTime:0.002541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307392,886028,661784,791869,280738,341221,1024533,303834,265658,231014,70416,847378,448503,504458,89556,139072,839015,84864,321933,405191,747842,802904,777219,194083,60281,1033443,853314,686266,435768,583147,101577,333443,218117,21537,6512,7819,871267,777250,372275,721080,442078,50726,831068,176631,57876,598651,661223,687734,603044,328497,668683,69815,164168,754254,925005,244159,434803,894955,560532,183343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505595 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505595 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001797s ]