SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326040 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326040 [ RunTime:0.001413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031434,18098,903745,704683,314005,366261,15708,189913,440766,202528,178240,282659,444900,437030,774402,253618,971028,893363,86744,545366,674642,66788,795949,364741,254635,977654,850393,254584,547720,917917,794548,235375,822087,194949,7427,635240,511781,207815,813711,702851,92824,725894,869287,753154,1012204,721540,1023695,593548,980868,501136,143759,4160,428367,364542,264081,505324,31533,38664,162618,941895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]