SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001808s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315071 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315071 [ RunTime:0.002600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (740758,126370,174550,17509,917246,779383,963518,558120,630369,281940,777725,679873,501160,301999,208465,933010,348488,55314,597780,368241,963681,235191,456227,439886,579965,935,514858,533585,477085,837097,626622,541436,510177,94353,767237,1000239,512580,337430,1042429,898130,968775,593578,372888,587010,829901,988084,604891,316724,48191,1005017,966414,116292,169455,207733,965402,167159,540529,371320,1037361,764627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]