SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003920s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318456 LIMIT 1 [ RunTime:0.001778s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318456 [ RunTime:0.001184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003164,264866,918160,695857,507403,231114,628370,803242,527736,167896,367584,868893,828004,554548,711410,878434,479969,505129,805538,621765,672907,628496,326292,993896,71537,945591,69830,59195,866134,858273,310946,919500,23817,262348,1017510,193679,871711,126205,116150,627599,191475,436835,834083,83771,869920,951302,988359,692252,751793,673820,957725,459006,198567,35930,97875,87677,668146,584989,758880,840403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318456 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318456 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]