SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464603 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464603 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198378,11667,329899,883160,845720,871375,346040,953689,577814,23318,647946,565415,408033,338374,371476,577078,187945,396013,605266,348639,269559,518794,761805,660878,753263,84641,627356,137361,150074,388559,117807,450828,818861,71860,309337,455276,159255,949927,361760,265501,1015145,123400,260199,801642,462676,300610,540112,463765,107239,2990,832454,715596,68069,903698,372615,616371,321117,165406,831042,738615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]