SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423589 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423589 [ RunTime:0.003569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533354,904026,647937,831853,556072,720608,243173,1016866,1002962,932335,217843,10970,439429,170579,279817,1036780,1016112,527467,149805,630006,728510,992318,822337,481294,359252,713080,387535,920646,740855,1029571,742836,8143,515008,982125,714067,1028159,261563,330980,46395,289153,715017,686686,75384,361613,363789,429020,540862,492036,630716,180217,717928,50855,517827,822580,986975,896715,102004,371680,1006798,194738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]