SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301244 LIMIT 1 [ RunTime:0.000600s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301244 [ RunTime:0.002541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585861,70532,262331,179712,163392,368552,686846,582007,910414,469694,374177,121293,206250,819816,675692,610460,958694,39691,710538,383176,1039987,807150,6739,1048016,434795,139848,860381,602001,32128,1030293,501771,262729,968463,628854,1013544,746078,323617,751123,890885,623395,1028410,442250,143789,464520,900983,940886,795337,284628,341431,577592,396461,253832,642475,267457,559177,807385,831942,170396,337912,185598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]