SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681840 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681840 [ RunTime:0.002031s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92306,454434,79516,798409,581525,639461,922986,683698,582403,372105,2196,710635,303302,856841,1044643,558292,2556,670249,1028953,1009977,54168,130046,411106,891173,220520,76682,509262,961913,898561,98147,905438,549566,185068,750842,780255,940841,202184,67879,447810,428563,862307,85612,500902,607991,725109,44128,729408,407763,594274,613032,575397,823669,901249,229746,860145,708644,760383,396823,93053,537994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]