SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004588s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1032240 LIMIT 1 [ RunTime:0.001238s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1032240 [ RunTime:0.003166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30287,288739,923353,725509,607449,87864,361233,256018,22099,574835,191330,199100,926616,293308,512993,408445,470061,719648,138392,9373,351540,941686,551518,999164,909488,469860,1037432,510605,347719,307427,346193,736890,510228,474675,507107,137589,127390,976163,397168,656881,120996,578843,144002,52853,543914,868073,774069,1016374,730649,90375,933872,881918,466525,931062,832950,857732,121286,748645,442434,230270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1032240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1032240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003041s ]