SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51834 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51834 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756797,578949,671146,365924,872109,49716,188132,232797,392839,465528,18401,691350,8036,282814,19591,574083,335997,1007196,986109,1042083,109039,527105,184191,934655,992786,953920,979018,451223,319270,572930,522383,302511,54571,832677,211375,437024,908461,768385,440362,955834,934357,729248,160224,813690,859303,774322,557034,321825,271674,119104,597563,356955,852042,830362,395748,224167,417275,259279,316606,892237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]