SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542807 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542807 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938435,571036,452137,577189,48595,816837,737322,510364,179755,552124,177677,266219,928355,231686,96516,39288,127461,42099,691089,744083,779166,170896,267897,544616,688315,539187,258127,768724,824393,377183,837006,97271,894912,504456,613297,1040337,279311,762311,695042,947292,37617,4806,513599,77141,383742,322597,94572,299765,148240,10091,666806,143966,1002500,880278,978666,343353,422749,730924,107223,277634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]