SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114438 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114438 [ RunTime:0.002105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603354,354270,85017,357481,814344,839858,174788,182974,1013413,895075,703377,91366,970707,271958,946710,605951,783629,271316,949149,871325,24028,1035558,467046,917258,272522,858524,325271,1011017,222476,27151,8645,575382,21093,541735,372957,270244,835691,548098,546997,601597,585972,929791,497918,598234,410874,1011382,979165,849221,746833,929829,273929,93490,338341,1040278,671092,860341,102014,698483,940692,865117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]