SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98030 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98030 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58091,679160,488465,474416,642686,170756,151361,837931,197420,469309,221339,941072,951691,984123,281217,574783,237273,477508,386221,882520,962460,1037274,336738,309627,714035,1045445,968920,767648,454162,878895,965142,204392,1068,703577,173891,41852,872997,121417,548336,1029415,807177,814915,11403,330049,397310,698646,507645,358686,1000336,712733,140618,286407,931502,894397,467691,737715,657153,284644,822694,643051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]