SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005694 LIMIT 1 [ RunTime:0.002444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005694 [ RunTime:0.003579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842754,716036,844542,627536,74192,834601,765542,858300,749909,1003401,407281,483135,378699,35964,547811,38201,936300,11473,679489,1047737,1019831,229724,356745,734153,131390,890722,965610,141111,1016342,240487,512192,126581,422751,974137,474134,121603,134043,657579,386637,30009,572167,559870,422067,137367,289049,1043909,365798,505788,113913,948510,682314,245233,488665,692643,379673,74657,304855,418080,300770,287124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.021442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]