SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027010 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027010 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414801,1000892,327262,610703,113157,812580,10749,284818,758539,632541,642989,541485,827767,354253,377046,828663,744605,656767,491852,958247,715780,1006611,315994,425526,846102,305097,142784,639723,259861,563360,156913,654521,327374,559813,813113,194840,595223,522998,791251,472131,905828,105715,775510,323163,145528,789006,856382,956115,90517,699693,812768,864099,833775,639017,880758,230052,368231,230391,57428,207525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]