SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419474 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419474 [ RunTime:0.001447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11236,533753,72003,135239,781843,614547,736348,703662,962239,593660,789017,597275,550607,153478,769858,121025,1006669,288910,784185,797943,1010874,1007321,540696,825905,690333,891196,792231,849831,583133,283914,738384,660492,451586,674160,658931,441129,281212,354317,735110,248513,39093,317672,255291,518075,404041,956363,1014728,808496,350183,963447,625675,476524,301679,625844,595308,935269,774438,403714,708463,187445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]