SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001681s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493913 LIMIT 1 [ RunTime:0.000621s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493913 [ RunTime:0.002778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810518,1046418,968595,170527,92036,98620,445852,871478,494449,581492,750460,357300,538762,821001,17602,43056,202678,22012,294896,126752,774760,476175,899455,398027,195747,805071,396767,1002565,1007951,764066,1026789,864775,331978,103728,76925,805905,488577,881256,816684,605156,824917,523061,654519,143257,546247,163258,138400,131186,732224,301527,882301,422820,825045,91054,1023431,950940,248735,689708,825635,762005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]