SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018940 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018940 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449156,502907,744232,439919,156031,41801,364468,261279,10867,350859,843253,380056,127353,504658,851992,546179,349373,1015558,509981,740641,683955,479791,173803,831120,1041256,41813,1010341,860966,249477,884429,637845,97895,580416,634819,597528,492747,902738,503109,446502,66795,557028,574363,218611,941681,586054,266535,653257,141495,747238,59190,748301,42077,507469,78634,674131,1032334,579949,272010,745778,752710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]