SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283022 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283022 [ RunTime:0.003104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441198,420900,736633,362481,44000,41267,510365,693312,994438,783321,396355,486008,926698,1027621,383766,253806,444670,962015,352841,431693,524126,658292,220263,1031039,120646,418352,316261,772902,807149,808059,448378,732925,652681,422175,861779,116415,979406,908048,823204,952389,939545,476027,650129,921090,913824,281363,651961,950024,728561,442049,26928,632257,483865,851871,197392,407438,977393,179325,603711,838228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]