SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001880s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563631 LIMIT 1 [ RunTime:0.000618s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563631 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629345,216594,292921,182151,95002,352737,619797,411598,643007,389715,372069,286017,396245,720988,762875,516307,910611,267660,136982,592019,864036,486135,864282,88081,1010225,32400,104633,463010,837956,639729,94119,964604,100992,976488,656244,89039,123064,648528,457829,500143,396385,226285,66360,741011,984188,416835,232371,20808,657720,693502,482445,335227,985988,289288,519518,124258,539749,1034213,187435,897709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]