SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310058 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310058 [ RunTime:0.001519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606453,470274,182032,778159,733564,406674,371452,207545,726221,389642,950110,58282,978623,587460,433235,371057,468112,587691,70211,833399,414271,378594,414830,971776,821439,398614,755407,299416,323294,125813,102827,816065,297543,15884,30558,104350,845361,842246,649255,344900,855795,450368,1018532,765499,165685,506305,260230,573102,209361,42903,499257,536831,281466,914754,193898,76141,721370,384871,443908,403427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]