SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53400 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53400 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256027,100552,787996,395761,557788,644295,224907,181135,1037727,89120,977568,331274,585506,685420,812046,760262,899184,264789,367063,896602,1040623,608152,236381,846938,124807,566990,207115,128095,105248,311626,373788,611493,876929,366191,157955,399910,711993,43520,454313,275818,381246,24527,441480,324433,618315,645010,418892,301808,778197,566654,10720,703948,180449,583889,799706,423152,19289,348760,262875,577831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]