SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300383 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300383 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344835,911673,538453,469766,349555,387229,1044228,653120,527287,191391,112954,609390,1035270,860635,476331,277706,507082,866873,543935,467847,887379,454211,900014,295985,1012435,269825,884698,600313,522423,210464,109502,781905,625510,483908,393275,326751,326825,316797,1004120,455551,579714,244727,893977,865431,578233,280415,703885,672459,21544,747237,834519,181814,359945,910033,347101,252265,509435,238502,826805,589196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002461s ]