SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045008 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045008 [ RunTime:0.002611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432410,341214,744228,278893,642352,855828,232317,490557,445584,419249,858350,457863,159396,734394,144886,540634,19123,121383,607890,39113,882246,304185,170895,851861,685529,475521,809415,783649,619532,110422,101466,938224,95905,324829,272649,553052,895702,27453,291251,677562,927118,397561,424278,269773,284217,37961,188754,1025827,804809,599059,90452,302082,290978,833656,853204,457210,967193,1565,711936,328842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]