SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420728 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420728 [ RunTime:0.002432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426333,303487,515230,412406,707058,679226,736597,975921,706782,931343,163613,649689,370059,340070,571057,699695,193206,462522,273687,891094,449404,638120,104930,1016021,85490,115322,160743,584511,344677,9982,27101,390100,105300,872202,85357,199155,397293,642179,942506,208284,606994,189001,71381,98599,703267,1030923,440932,762502,972576,711019,17832,153127,714442,358229,639390,73276,589838,297139,40870,871220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]