SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001743s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201227 LIMIT 1 [ RunTime:0.001104s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201227 [ RunTime:0.002570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20045,822985,1010556,82380,976232,956592,752138,800404,459114,619982,882770,524736,582131,6406,241653,919838,243701,441186,110999,1029899,56023,126216,345657,229617,965731,946984,773831,1030685,75147,954739,69233,841965,349972,137356,764487,647286,956543,351969,593373,1066,275990,588131,1020481,867197,986021,130742,355968,878181,567473,842801,845362,161811,629891,211845,797364,154881,604413,789635,773770,813598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]