SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 117640 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 117640 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470615,898943,116669,580186,791511,522148,215551,207299,969922,862814,565298,1022238,650705,450107,114722,3968,656648,471954,522945,549427,299526,1034294,343371,650095,516238,923302,779659,962644,780070,865200,1026063,106,715901,878122,994035,1014846,878816,588965,357098,135180,664733,580652,990346,311628,951685,478023,452345,297716,93328,697198,304681,748361,567365,611550,169387,670235,875716,36428,950716,711098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 117640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 117640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]