SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201226 LIMIT 1 [ RunTime:0.000637s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201226 [ RunTime:0.004306s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278358,672168,651784,318928,616422,900572,767320,232055,704481,275476,655067,298654,614002,994510,73628,400394,929707,724710,931599,696194,357557,785303,947006,341572,1040162,445409,1032844,34882,867982,173442,777488,966685,1034506,671806,661177,87175,364046,293864,809967,532578,705242,467648,507938,188525,517309,234091,251170,829865,182682,323299,28463,70176,177366,690843,577980,1015266,357289,54375,514799,769881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003735s ]