SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508293 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508293 [ RunTime:0.002519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489747,26701,995119,169630,411344,1040155,327584,738958,591151,988748,668831,529521,387444,131011,483114,767157,44216,585990,183622,285078,132172,350129,523078,222674,709083,780423,363701,381974,915203,639924,276837,656078,184672,1023760,293506,721608,490136,1038293,142737,935880,294239,617496,695517,869290,58942,170468,188456,82465,577182,422791,82070,635588,76995,397433,446538,920795,210041,1027832,210156,291092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]