SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109214 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109214 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618829,361888,426472,647991,737543,9820,165684,1028864,1038900,736812,564999,168077,21664,646343,816251,196269,457642,563081,907329,726960,952282,275446,355455,269354,810784,953050,170622,1034930,1145,630328,250920,56615,106083,742297,470415,269486,922202,331720,244827,74717,633003,536042,416941,846137,417273,392505,34297,180271,977921,386071,704314,722781,141596,813614,244186,771428,377114,465769,771593,518306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]