SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493893 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493893 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993224,904594,770997,609678,11707,508918,483800,375641,540254,962,867134,713246,792699,884603,86187,142391,815223,755292,499404,1024884,1041246,43274,585097,953625,694401,76299,740312,1035531,113642,498276,596316,953869,977682,449513,486542,536621,284026,167368,90019,87612,53861,478002,556523,823874,980348,971371,469012,383447,231004,446156,408624,434963,240126,137762,740235,146069,535872,322764,896408,801819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]