SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431871 LIMIT 1 [ RunTime:0.001604s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431871 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166412,464634,253989,430252,741710,92429,617075,1001532,783979,337352,77767,676813,403733,596675,704917,511752,467164,628011,172317,41086,1006531,550758,942549,163423,71643,693218,374932,394880,8705,213829,757277,435755,267936,839711,71560,604414,682232,440317,715225,693071,693689,398225,24631,141088,830029,666302,45821,878187,494497,541440,829804,402916,297386,839578,703526,702864,1030006,6182,578229,727695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]