SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017862 LIMIT 1 [ RunTime:0.002913s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017862 [ RunTime:0.004467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386476,497493,256907,752699,800828,40402,1024163,1026389,366755,61013,973757,381778,519357,253842,643505,718569,634373,147632,856864,344086,912664,646206,841859,333203,769980,142539,25274,772006,887830,870479,348602,1023793,839670,6123,154619,511708,561321,143856,159794,425676,98904,814467,479112,973815,460884,151062,217745,551461,118029,994978,572673,337312,264635,159465,477771,602044,467738,409954,258553,383689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017862 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017862 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]