SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 169591 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 169591 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298317,953309,201743,1044599,121157,804090,466296,421697,813773,751939,370737,135303,580334,1000225,281689,272857,543494,526857,996361,857726,882342,216502,840565,369377,656979,709421,128663,441078,48056,825931,685243,93725,584427,692545,481877,737230,307895,1011445,431482,284208,731423,1026900,858786,290883,875303,292261,42419,486489,308543,1002879,114717,1006837,965391,893241,588127,693129,190406,610142,11100,714544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 169591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 169591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]