SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017787 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017787 [ RunTime:0.002124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855903,608404,291917,823416,373994,589370,643875,477535,342717,635949,449199,276729,962793,502289,126019,773159,640775,511519,1041459,711283,108453,601040,208180,200658,948417,458672,525954,420079,727141,49926,686565,537101,345445,556353,699528,770407,546548,31786,412460,902702,706250,683834,146234,410063,554412,796267,151064,704886,325676,556704,1034082,655661,157629,953625,422126,814425,267867,84548,1042452,966990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]