SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255618 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255618 [ RunTime:0.002247s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159318,828883,977279,297422,39651,17950,541172,878039,170304,250607,393528,54011,719644,315337,424147,250560,531523,610844,617101,254663,566116,475265,451828,686070,413449,975055,77522,369709,787231,64916,408461,949490,1020903,84983,987105,674913,558771,602590,300838,547549,505283,560255,933554,589070,895946,975593,12571,270497,918168,850356,141172,207038,227557,727225,296436,544427,270921,599924,911018,442145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]