SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005160 LIMIT 1 [ RunTime:0.001174s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005160 [ RunTime:0.002173s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113248,594583,652459,8950,894676,936386,580084,746878,169728,538246,593066,984696,272632,615083,1032039,333350,479037,142549,138854,346384,36769,889343,609278,194108,959658,930892,661538,535471,277601,707186,760158,219726,490975,794606,346569,94300,381541,97531,711514,199690,443828,671474,149994,986039,586719,775957,179596,1025523,940705,805157,757963,455949,597415,245823,619249,900522,58784,1040218,125280,507947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000742s ]