SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501095 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501095 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986291,850144,672471,753094,814205,305027,963961,448681,559409,36655,538890,403971,263915,554437,318858,385686,719923,524381,1044631,731766,566588,239304,972332,935589,812827,215163,170469,614946,974672,78084,652611,900666,292117,611257,1001355,618674,1002359,363778,416802,802147,804178,465753,811158,551898,840670,513683,965483,987457,919124,334393,592371,153829,92358,89368,634139,360512,761395,785444,425601,684828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]