SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415770 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415770 [ RunTime:0.003478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690855,847890,671487,378282,978564,1046276,81667,107915,150926,804100,488514,346046,804210,885900,68708,653265,371690,959480,842312,68911,412421,717612,226446,207821,792385,740502,369358,297416,1015722,240715,543241,644595,450283,228779,352890,623845,238846,871593,923121,575856,913604,708310,900425,100933,346801,687456,176113,53696,861935,857971,193152,690596,348318,346919,911551,587849,988236,864018,170265,159794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]