SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486413 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486413 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323325,178811,253284,750330,1037081,358868,527156,308002,584192,293778,62970,137944,52086,262913,327651,769528,840396,907046,119334,890307,299967,672583,426670,639908,975469,741692,568860,461100,592099,143614,783118,896247,883981,102248,229384,605719,669840,398882,277067,247935,461638,265670,440079,894444,997407,871313,253490,986269,205319,297500,86597,799986,906508,472488,738200,731698,457597,464526,968387,100793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]